﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using QLTV_Public;
using System.Data;

namespace QLTV_Data
{
  public  class ThongKe_Data
    {
      KetNoiCSDL_Data kn = new KetNoiCSDL_Data();
      public DataTable LayDuLieu()
      {
          return kn.LayDuLieu("ThongKe_TheLoai");
      }
      public DataTable taoBang(string sql)
      {
          return kn.taobang(sql);
      }
      public DataTable ChiTiet_TheLoai(TheLoai_public tenTheLoai)
      {
          int n = 1;
          string[]name=new string[n];
          object[] value = new object[n];
          name[0] = "@TenTheLoai";
          value[0] = tenTheLoai.TenTheLoai;
          return kn.LayDuLieu("ChiTiet_TheLoai",name,value,n);
      }
      public DataTable ThongKe_ViPham()
      {
          return kn.LayDuLieu("ThongKe_ViPham");
      }
      public DataTable ChiTiet_ThongKe_ViPham(Lop_Public tenlop)
      {
          int n = 1;
          string[] name = new string[n];
          object[] value = new object[n];
          name[0] = "@TenLop";
          value[0] = tenlop.TenLop;
          return kn.LayDuLieu("ChiTiet_ThongKe_ViPham", name, value, n);
      }
      public DataTable ThongKe_QuaHan_DaTra()
      {
          return kn.LayDuLieu("ThongKe_QuaHan_DaTra");
      }
      public DataTable ThongKe_QuaHan_DangMuon()
      {
          return kn.LayDuLieu("ThongKe_QuaHan_DangMuon");
      }
      public DataTable ThongKe_TaiLieu_DangMuon()
      {
          return kn.LayDuLieu("ThongKe_TaiLieu_DangMuon");
      }
    }
}
